package com.sanhuo.idms.dao;

import com.sanhuo.idms.entity.ElectricScheduleDay;
import com.sanhuo.idms.entity.ElectricScheduleWeek;
import com.sanhuo.triild.Basic.BaseMapper;
import com.sanhuo.triild.annotation.Mapper;
import com.sanhuo.triild.annotation.Select;

import java.util.List;

@Mapper
public interface ElectricScheduleWeekMapper extends BaseMapper<ElectricScheduleWeek> {

    @Select("select consume from electric_schedule_week where dormId = #{dormId}" +
            " and createTime >= #{beginTime} and createTime <= #{endTime} order by createTime desc")
    List<Double> findWeekByDorm(String dormId, String beginTime, String endTime);


}
